{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Input Form","Print Form","Data","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input Form","index":0,"n_rows":71,"n_cols":29,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,4,14],[5,0,5,14],[13,2,13,3],[43,2,43,3],[37,7,39,10],[40,7,40,10],[42,2,42,3],[6,2,6,3],[11,2,11,3],[12,2,12,3],[8,2,8,3],[10,5,10,12],[11,5,11,12],[12,5,14,5],[14,15,14,16],[6,0,6,1],[7,0,8,1],[53,7,53,8],[12,6,14,13],[7,2,7,3],[9,2,9,3],[10,2,10,3],[38,11,43,14],[6,5,6,12],[14,2,14,4],[37,2,39,5],[40,2,40,5],[7,5,7,12],[8,5,8,12],[9,5,9,12]]}
["Vocational-Technical Education Transportation\n Reimbursement Form FY13\nV.S.A. Title 16: Education, Chapter 37: Technical Training, Subchapter V., § 1563. Transportation Assistance\n as amended by Sec. 7 of Act 66 of the 2007 Legislative Session",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Visibility Flag1",{"$f":"IF(N9=\"\",1,IF($N$9=\"District Operated\",1,0))","v":1},null,null,"Detail Flag",{"$f":"IF(OR(Q17=\"No\",Q18=\"No\",Q19=\"No\",Q20=\"No\",Q21=\"No\",Q22=\"No\",Q23=\"No\",Q24=\"No\",Q25=\"No\",Q26=\"No\",Q27=\"No\",Q28=\"No\",Q29=\"No\",Q30=\"No\",Q31=\"No\",Q32=\"No\",Q33=\"No\",Q34=\"No\",Q35=\"No\",Q36=\"No\"),0,1)","v":0},null,"<---Hidden Columns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Visibility Flag2",{"$f":"IF(OR($N$9=\"District Operated\",$N$9=\"Reimbursement\"),1,0)","v":0},null,null,"Internal Flag",{"$f":"IF(N9=\"\",0,IF(N9=\"District Operated\",IF(OR(E7=\"\",E8=\"\",E11=\"\",E12=\"\",E13=\"\",E14=\"\",N7=\"\",N8=\"\",N9=\"\",C43=\"\",E43=\"\",F43=\"\"),0,1),1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Submittable Flag",{"$f":"IF(AND(AA1=1,AA2=1,AA3=1,AA4=1),1,0)","v":0},null,null,"Reimbursement Flag",{"$f":"IF(N9=\"Reimbursement\",IF(OR(E7=\"\",E8=\"\",E11=\"\",E12=\"\",E13=\"\",E14=\"\",N7=\"\",N8=\"\",N9=\"\",N10=\"\",C43=\"\",E43=\"\",F43=\"\"),0,1),1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract Flag",{"$f":"IF(LEFT(N9,8)=\"Contract\",IF(OR(E7=\"\",E8=\"\",E11=\"\",E12=\"\",E13=\"\",E14=\"\",N7=\"\",N8=\"\",N9=\"\",N10=\"\",N11=\"\",N12=\"\",C43=\"\",E43=\"\",F43=\"\"),0,1),1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filename:",{"$f":"E9&\" Sem \"&E11&\" SY \"&E12","v":" Sem  SY "}]
[]
["Status",null,"School District Type:",null,null,"Estimated Number of days Transportation is provided to the Tech Ctr this year?",null,null,null,null,null,null,null,null,"TARF ID",null,null,null,null,null,"Subject:",{"$f":"V5&\" Tech Ed Transportation form\"","v":" Sem  SY  Tech Ed Transportation form"}]
[{"$f":"IF(W3=1,\"Submittable\",\"Incomplete\")","v":"Incomplete"},null,"School District:",null,null,{"$f":"\"Previous Year's Semester \"&E11&\" Actual Cost:\"","v":"Previous Year's Semester  Actual Cost:"}]
[null,null,"LEA ID:",null,{"$f":"IF(E8=\"\",\"\",VLOOKUP(E8,Lists!$C$6:$D$179,2,FALSE))","v":""},"How is Tech Ed transportation paid?",null,null,null,null,null,null,null,null,"Form ID"]
[null,null,"Fiscal Year:",null,"2013",{"$f":"IF($N$9=\"Contract by Trip\",\"What is the contracted per Trip Rate?\",IF($N$9=\"Reimbursement\",\"What is the Reimbursement Rate?\",IF($N$9=\"Contract by Mile\",\"What is the contracted per Mile Rate?\",\"\")))","v":""},null,null,null,null,null,null,null,null,{"$f":"E9&E11&E12","v":""}]
[null,null,"Semester:",null,null,{"$f":"IF($N$9=\"Contract by Trip\",\"Who do you contract with?\",IF($N$9=\"Reimbursement\",\"\",IF($N$9=\"Contract by Mile\",\"Who do you contract with?\",\"\")))","v":""},null,null,null,null,null,null,null,null,"Per mile Est."]
[null,null,"School Year:",null,null,{"$f":"IF($N$9=\"Contract by Trip\",\"How much is the \"&E12&\" contract for all Tech Ed Buses?\",IF($N$9=\"Reimbursement\",\"\",IF($N$9=\"Contract by Mile\",\"How much is the \"&E12&\" contract for all Tech Ed Buses?\",\"\")))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(A8=\"Submittable\",IF(ISERROR(Data!S34*1=TRUE),0,Data!S34),0)","v":0}]
[null,null,"Superintendent:",null,null,{"$f":"IF(OR(E9=\"P005\",E9=\"J242\"),\"Please fill out the table below the form\",\"\")","v":""}]
[null,null,"Supervisory Union:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Does not Print"]
["Line","Vehicle #","Driver's Name","Vehicle Capacity","Trip Type","Technical Center","Number of one-way trips each day","Number of miles per one-way trip each day","Number of Technical Education Students\n(Residents)","Technical Education Students\n(Non-Residents)","Number of other Students","Estimated number of days this vehicle will travel in this Semester","% Reimbursed","Paid Rate","Estimated Payment",{"$f":"IF(N9=\"Contract by trip\",\"Please convert the by trip rate to a per mile rate\",IF(N10=\"Multiple\",\"Contract/ Reimbursement Custom Rates\",\"Do Not use this column\"))","v":"Do Not use this column"},"Is Row Complete?"]
[1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G17>0,IF(I17+J17+K17=0,1,IF(ROUND((I17+J17)/(I17+J17+K17),4)>=0.5,1,ROUND((I17+J17)/(I17+J17+K17),4))),\"\")","v":""},{"$f":"IF(Q17=\"No\",0,IF(G17=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P17))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P17)))))","v":0},{"$f":"IF(ISERROR(IF(G17>0,G17*H17*M17*L17*N17,\"\"))=TRUE,\"\",IF(G17>0,ROUND(G17*H17*M17*L17*N17,2),\"\"))","v":""},null,{"$f":"IF(AND(N9=\"Contract by trip\",$P$17=\"\"),\"No\",IF(AND(A17=1,G17=\"\"),\"No\",IF(AND($N$10=\"Multiple\",G17>0,P17=\"\"),\"No\",IF(OR(B17<>\"\",C17<>\"\",D17<>\"\",E17<>\"\",F17<>\"\",G17<>\"\",H17<>\"\",I17<>\"\",K17<>\"\",L17<>\"\"),IF(OR(B17=\"\",C17=\"\",F17=\"\",D17=\"\",E17=\"\",H17=\"\",I17=\"\",K17=\"\",L17=\"\"),\"No\",\"Yes\"),\"\"))))","v":"No"}]
[{"$f":"+A17+1","v":2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G18>0,IF(I18+J18+K18=0,1,IF(ROUND((I18+J18)/(I18+J18+K18),4)>=0.5,1,ROUND((I18+J18)/(I18+J18+K18),4))),\"\")","v":""},{"$f":"IF(Q18=\"No\",0,IF(G18=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P18))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P18)))))","v":""},{"$f":"IF(ISERROR(IF(G18>0,G18*H18*M18*L18*N18,\"\"))=TRUE,\"\",IF(G18>0,ROUND(G18*H18*M18*L18*N18,2),\"\"))","v":""},null,{"$f":"IF(AND(N10=\"Contract by trip\",$P$17=\"\"),\"No\",IF(AND(A18=1,G18=\"\"),\"No\",IF(AND($N$10=\"Multiple\",G18>0,P18=\"\"),\"No\",IF(OR(B18<>\"\",C18<>\"\",D18<>\"\",E18<>\"\",F18<>\"\",G18<>\"\",H18<>\"\",I18<>\"\",K18<>\"\",L18<>\"\"),IF(OR(B18=\"\",C18=\"\",F18=\"\",D18=\"\",E18=\"\",H18=\"\",I18=\"\",K18=\"\",L18=\"\"),\"No\",\"Yes\"),\"\"))))","v":""}]
[{"$f":"+A18+1","v":3},null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q19=\"No\",0,IF(G19=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P19))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P19)))))","v":""},"",null,""]
[4,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q20=\"No\",0,IF(G20=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P20))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P20)))))","v":""},"",null,""]
[5,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q21=\"No\",0,IF(G21=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P21))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P21)))))","v":""},"",null,""]
[6,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q22=\"No\",0,IF(G22=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P22))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P22)))))","v":""},"",null,""]
[7,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q23=\"No\",0,IF(G23=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P23))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P23)))))","v":""},"",null,""]
[8,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q24=\"No\",0,IF(G24=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P24))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P24)))))","v":""},"",null,""]
[9,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q25=\"No\",0,IF(G25=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P25))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P25)))))","v":""},"",null,""]
[10,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q26=\"No\",0,IF(G26=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P26))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P26)))))","v":""},"",null,""]
[11,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q27=\"No\",0,IF(G27=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P27))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P27)))))","v":""},"",null,""]
[12,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q28=\"No\",0,IF(G28=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P28))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P28)))))","v":""},"",null,""]
[13,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q29=\"No\",0,IF(G29=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P29))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P29)))))","v":""},"",null,""]
[14,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q30=\"No\",0,IF(G30=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P30))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P30)))))","v":""},"",null,""]
[15,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q31=\"No\",0,IF(G31=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P31))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P31)))))","v":""},"",null,""]
[16,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q32=\"No\",0,IF(G32=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P32))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P32)))))","v":""},"",null,""]
[17,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q33=\"No\",0,IF(G33=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P33))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P33)))))","v":""},"",null,""]
[18,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q34=\"No\",0,IF(G34=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P34))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P34)))))","v":""},"",null,""]
[19,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q35=\"No\",0,IF(G35=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P35))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P35)))))","v":""},"",null,""]
[20,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q36=\"No\",0,IF(G36=\"\",\"\",IF($N$9=\"Contract by trip\",MIN(Data!$D$6,$P$17),IF(ISERROR(MIN(Data!$D$6,'Input Form'!$N$10,P36))=TRUE,\"\",MIN(Data!$D$6,'Input Form'!$N$10,P36)))))","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(O17:O36)","v":0}]
[null,null,{"$f":"IF(A8=\"incomplete\",\"Please complete highlighted fields.\",\"\")","v":"Please complete highlighted fields."},null,null,null,null,null,null,null,null,null,"Notes:"]
[]
[]
[null,null,"Superintendent's Signature",null,null,null,null,"Date"]
[]
[]
[null,null,"Preparer's Name",null,"Preparer's E-mail","Phone #"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(E8=\"\",\"\",E8)","v":""},{"$f":"+E52","v":0}]
[null,null,null,null,null,"School Districts","LEA ID","Number of Tech Ed Students","Percent of Students"]
[null,null,null,null,null,null,{"$f":"IF(F56=\"\",\"\",VLOOKUP(F56,Lists!$I$6:$J$171,2,FALSE))","v":""},null,{"$f":"IF(H56=\"\",\"\",ROUND(H56/$H$71,8))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F57=\"\",\"\",VLOOKUP(F57,Lists!$I$6:$J$171,2,FALSE))","v":""},null,{"$f":"IF(H57=\"\",\"\",ROUND(H57/$H$71,8))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F58=\"\",\"\",VLOOKUP(F58,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F59=\"\",\"\",VLOOKUP(F59,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F60=\"\",\"\",VLOOKUP(F60,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F61=\"\",\"\",VLOOKUP(F61,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F62=\"\",\"\",VLOOKUP(F62,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F63=\"\",\"\",VLOOKUP(F63,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F64=\"\",\"\",VLOOKUP(F64,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F65=\"\",\"\",VLOOKUP(F65,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F66=\"\",\"\",VLOOKUP(F66,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F67=\"\",\"\",VLOOKUP(F67,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F68=\"\",\"\",VLOOKUP(F68,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F69=\"\",\"\",VLOOKUP(F69,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,null,{"$f":"IF(F70=\"\",\"\",VLOOKUP(F70,Lists!$I$6:$J$171,2,FALSE))","v":""},null,""]
[null,null,null,null,null,{"$f":"COUNTA(F56:F70)","v":0},null,{"$f":"SUM(H56:H70)","v":0},{"$f":"SUM(I56:I70)","v":0}]

{"sheet":"Print Form","index":1,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,0,8,1],[8,2,8,3],[7,2,7,3],[7,5,7,12],[8,5,8,12],[0,0,4,14],[5,0,5,14],[6,0,6,1],[6,2,6,3],[6,5,6,12],[9,2,9,3],[10,2,10,3],[11,2,11,3],[9,5,9,12],[10,5,10,12],[11,5,11,12],[40,2,40,5],[12,2,12,3],[12,6,14,13],[13,2,13,3],[37,7,39,10],[38,11,43,14],[40,7,40,10],[42,2,42,3],[43,2,43,3],[12,5,14,5],[14,2,14,4],[37,2,39,5]]}
["Vocational-Technical Education Transportation\n Reimbursement Form FY12\nV.S.A. Title 16: Education, Chapter 37: Technical Training, Subchapter V., § 1563. Transportation Assistance\n as amended by Sec. 7 of Act 66 of the 2007 Legislative Session"]
[]
[]
[]
[]
[]
["Status",null,"School District Type:",null,{"$f":"'Input Form'!E7","v":0},"Estimated Number of days Transportation is provided to the Tech Ctr this year?",null,null,null,null,null,null,null,{"$f":"'Input Form'!N7","v":0},"TARF ID"]
[{"$f":"+'Input Form'!A8:B9","v":"Incomplete"},null,"School District:",null,{"$f":"'Input Form'!E8","v":0},{"$f":"\"Previous Year's Semester \"&E11&\" Actual Cost:\"","v":"Previous Year's Semester 0 Actual Cost:"},null,null,null,null,null,null,null,{"$f":"'Input Form'!N8","v":0}]
[null,null,"LEA ID:",null,{"$f":"'Input Form'!E9","v":""},"How is Tech Ed transportation paid?",null,null,null,null,null,null,null,{"$f":"'Input Form'!N9","v":0},"Form ID"]
[null,null,"Fiscal Year:",null,{"$f":"'Input Form'!E10","v":"2013"},{"$f":"IF($N$9=\"Contract by Trip\",\"What is the contracted per Trip Rate?\",IF($N$9=\"Reimbursement\",\"What is the Reimbursement Rate?\",IF($N$9=\"Contract by Mile\",\"What is the contracted per Mile Rate?\",\"\")))","v":""},null,null,null,null,null,null,null,{"$f":"IF('Input Form'!N10=\"\",\"\",'Input Form'!N10)","v":""},{"$f":"+'Input Form'!O10","v":""}]
[null,null,"Semester:",null,{"$f":"'Input Form'!E11","v":0},{"$f":"IF($N$9=\"Contract by Trip\",\"Who do you contract with?\",IF($N$9=\"Reimbursement\",\"\",IF($N$9=\"Contract by Mile\",\"Who do you contract with?\",\"\")))","v":""},null,null,null,null,null,null,null,{"$f":"IF('Input Form'!N11=\"\",\"\",'Input Form'!N11)","v":""},"Per mile Est."]
[null,null,"School Year:",null,{"$f":"'Input Form'!E12","v":0},{"$f":"IF($N$9=\"Contract by Trip\",\"How much is the \"&E12&\" contract for all Tech Ed Buses?\",IF($N$9=\"Reimbursement\",\"\",IF($N$9=\"Contract by Mile\",\"How much is the \"&E12&\" contract for all Tech Ed Buses?\",\"\")))","v":""},null,null,null,null,null,null,null,{"$f":"IF('Input Form'!N12=\"\",\"\",'Input Form'!N12)","v":""},{"$f":"'Input Form'!O12","v":0}]
[null,null,"Superintendent:",null,{"$f":"'Input Form'!E13","v":0},"Mail Signed form to:","Sean Cousino\nVermont Department of Education\nSchool Finance\n120 State Street\nMontpelier VT 05620"]
[null,null,"Supervisory Union:",null,{"$f":"'Input Form'!E14","v":0}]
[]
["Line","Vehicle #","Driver's Name","Vehicle Capacity","Trip Type","Technical Center","Number of One-way trips each day","Number of miles per one-way trip each day","Number of Technical Education Students\n(Residents)","Technical Education Students\n(Non-Residents)","Number of other Students","Estimated num. of days this vehicle will travel in this semester","% Reimbursed","Paid Rate","Estimated Payment"]
[1,{"$f":"IF('Input Form'!B17=\"\",\"\",'Input Form'!B17)","v":""},{"$f":"IF('Input Form'!C17=\"\",\"\",'Input Form'!C17)","v":""},{"$f":"IF('Input Form'!D17=\"\",\"\",'Input Form'!D17)","v":""},{"$f":"IF('Input Form'!E17=\"\",\"\",'Input Form'!E17)","v":""},{"$f":"IF('Input Form'!F17=\"\",\"\",'Input Form'!F17)","v":""},{"$f":"IF('Input Form'!G17=\"\",\"\",'Input Form'!G17)","v":""},{"$f":"IF('Input Form'!H17=\"\",\"\",'Input Form'!H17)","v":""},{"$f":"IF('Input Form'!I17=\"\",\"\",'Input Form'!I17)","v":""},{"$f":"IF('Input Form'!J17=\"\",\"\",'Input Form'!J17)","v":""},{"$f":"IF('Input Form'!K17=\"\",\"\",'Input Form'!K17)","v":""},{"$f":"IF('Input Form'!L17=\"\",\"\",'Input Form'!L17)","v":""},{"$f":"IF('Input Form'!M17=\"\",\"\",'Input Form'!M17)","v":""},{"$f":"IF('Input Form'!N17=\"\",\"\",'Input Form'!N17)","v":0},{"$f":"IF('Input Form'!O17=\"\",\"\",'Input Form'!O17)","v":""}]
[{"$f":"+A17+1","v":2},{"$f":"IF('Input Form'!B18=\"\",\"\",'Input Form'!B18)","v":""},{"$f":"IF('Input Form'!C18=\"\",\"\",'Input Form'!C18)","v":""},{"$f":"IF('Input Form'!D18=\"\",\"\",'Input Form'!D18)","v":""},{"$f":"IF('Input Form'!E18=\"\",\"\",'Input Form'!E18)","v":""},{"$f":"IF('Input Form'!F18=\"\",\"\",'Input Form'!F18)","v":""},{"$f":"IF('Input Form'!G18=\"\",\"\",'Input Form'!G18)","v":""},{"$f":"IF('Input Form'!H18=\"\",\"\",'Input Form'!H18)","v":""},{"$f":"IF('Input Form'!I18=\"\",\"\",'Input Form'!I18)","v":""},{"$f":"IF('Input Form'!J18=\"\",\"\",'Input Form'!J18)","v":""},{"$f":"IF('Input Form'!K18=\"\",\"\",'Input Form'!K18)","v":""},{"$f":"IF('Input Form'!L18=\"\",\"\",'Input Form'!L18)","v":""},{"$f":"IF('Input Form'!M18=\"\",\"\",'Input Form'!M18)","v":""},{"$f":"IF('Input Form'!N18=\"\",\"\",'Input Form'!N18)","v":""},{"$f":"IF('Input Form'!O18=\"\",\"\",'Input Form'!O18)","v":""}]
[{"$f":"+A18+1","v":3},{"$f":"IF('Input Form'!B19=\"\",\"\",'Input Form'!B19)","v":""},{"$f":"IF('Input Form'!C19=\"\",\"\",'Input Form'!C19)","v":""},{"$f":"IF('Input Form'!D19=\"\",\"\",'Input Form'!D19)","v":""},{"$f":"IF('Input Form'!E19=\"\",\"\",'Input Form'!E19)","v":""},{"$f":"IF('Input Form'!F19=\"\",\"\",'Input Form'!F19)","v":""},{"$f":"IF('Input Form'!G19=\"\",\"\",'Input Form'!G19)","v":""},{"$f":"IF('Input Form'!H19=\"\",\"\",'Input Form'!H19)","v":""},{"$f":"IF('Input Form'!I19=\"\",\"\",'Input Form'!I19)","v":""},{"$f":"IF('Input Form'!J19=\"\",\"\",'Input Form'!J19)","v":""},{"$f":"IF('Input Form'!K19=\"\",\"\",'Input Form'!K19)","v":""},{"$f":"IF('Input Form'!L19=\"\",\"\",'Input Form'!L19)","v":""},{"$f":"IF('Input Form'!M19=\"\",\"\",'Input Form'!M19)","v":""},{"$f":"IF('Input Form'!N19=\"\",\"\",'Input Form'!N19)","v":""},{"$f":"IF('Input Form'!O19=\"\",\"\",'Input Form'!O19)","v":""}]
[4,{"$f":"IF('Input Form'!B20=\"\",\"\",'Input Form'!B20)","v":""},{"$f":"IF('Input Form'!C20=\"\",\"\",'Input Form'!C20)","v":""},{"$f":"IF('Input Form'!D20=\"\",\"\",'Input Form'!D20)","v":""},{"$f":"IF('Input Form'!E20=\"\",\"\",'Input Form'!E20)","v":""},{"$f":"IF('Input Form'!F20=\"\",\"\",'Input Form'!F20)","v":""},{"$f":"IF('Input Form'!G20=\"\",\"\",'Input Form'!G20)","v":""},{"$f":"IF('Input Form'!H20=\"\",\"\",'Input Form'!H20)","v":""},{"$f":"IF('Input Form'!I20=\"\",\"\",'Input Form'!I20)","v":""},{"$f":"IF('Input Form'!J20=\"\",\"\",'Input Form'!J20)","v":""},{"$f":"IF('Input Form'!K20=\"\",\"\",'Input Form'!K20)","v":""},{"$f":"IF('Input Form'!L20=\"\",\"\",'Input Form'!L20)","v":""},{"$f":"IF('Input Form'!M20=\"\",\"\",'Input Form'!M20)","v":""},{"$f":"IF('Input Form'!N20=\"\",\"\",'Input Form'!N20)","v":""},{"$f":"IF('Input Form'!O20=\"\",\"\",'Input Form'!O20)","v":""}]
[5,{"$f":"IF('Input Form'!B21=\"\",\"\",'Input Form'!B21)","v":""},{"$f":"IF('Input Form'!C21=\"\",\"\",'Input Form'!C21)","v":""},{"$f":"IF('Input Form'!D21=\"\",\"\",'Input Form'!D21)","v":""},{"$f":"IF('Input Form'!E21=\"\",\"\",'Input Form'!E21)","v":""},{"$f":"IF('Input Form'!F21=\"\",\"\",'Input Form'!F21)","v":""},{"$f":"IF('Input Form'!G21=\"\",\"\",'Input Form'!G21)","v":""},{"$f":"IF('Input Form'!H21=\"\",\"\",'Input Form'!H21)","v":""},{"$f":"IF('Input Form'!I21=\"\",\"\",'Input Form'!I21)","v":""},{"$f":"IF('Input Form'!J21=\"\",\"\",'Input Form'!J21)","v":""},{"$f":"IF('Input Form'!K21=\"\",\"\",'Input Form'!K21)","v":""},{"$f":"IF('Input Form'!L21=\"\",\"\",'Input Form'!L21)","v":""},{"$f":"IF('Input Form'!M21=\"\",\"\",'Input Form'!M21)","v":""},{"$f":"IF('Input Form'!N21=\"\",\"\",'Input Form'!N21)","v":""},{"$f":"IF('Input Form'!O21=\"\",\"\",'Input Form'!O21)","v":""}]
[6,{"$f":"IF('Input Form'!B22=\"\",\"\",'Input Form'!B22)","v":""},{"$f":"IF('Input Form'!C22=\"\",\"\",'Input Form'!C22)","v":""},{"$f":"IF('Input Form'!D22=\"\",\"\",'Input Form'!D22)","v":""},{"$f":"IF('Input Form'!E22=\"\",\"\",'Input Form'!E22)","v":""},{"$f":"IF('Input Form'!F22=\"\",\"\",'Input Form'!F22)","v":""},{"$f":"IF('Input Form'!G22=\"\",\"\",'Input Form'!G22)","v":""},{"$f":"IF('Input Form'!H22=\"\",\"\",'Input Form'!H22)","v":""},{"$f":"IF('Input Form'!I22=\"\",\"\",'Input Form'!I22)","v":""},{"$f":"IF('Input Form'!J22=\"\",\"\",'Input Form'!J22)","v":""},{"$f":"IF('Input Form'!K22=\"\",\"\",'Input Form'!K22)","v":""},{"$f":"IF('Input Form'!L22=\"\",\"\",'Input Form'!L22)","v":""},{"$f":"IF('Input Form'!M22=\"\",\"\",'Input Form'!M22)","v":""},{"$f":"IF('Input Form'!N22=\"\",\"\",'Input Form'!N22)","v":""},{"$f":"IF('Input Form'!O22=\"\",\"\",'Input Form'!O22)","v":""}]
[7,{"$f":"IF('Input Form'!B23=\"\",\"\",'Input Form'!B23)","v":""},{"$f":"IF('Input Form'!C23=\"\",\"\",'Input Form'!C23)","v":""},{"$f":"IF('Input Form'!D23=\"\",\"\",'Input Form'!D23)","v":""},{"$f":"IF('Input Form'!E23=\"\",\"\",'Input Form'!E23)","v":""},{"$f":"IF('Input Form'!F23=\"\",\"\",'Input Form'!F23)","v":""},{"$f":"IF('Input Form'!G23=\"\",\"\",'Input Form'!G23)","v":""},{"$f":"IF('Input Form'!H23=\"\",\"\",'Input Form'!H23)","v":""},{"$f":"IF('Input Form'!I23=\"\",\"\",'Input Form'!I23)","v":""},{"$f":"IF('Input Form'!J23=\"\",\"\",'Input Form'!J23)","v":""},{"$f":"IF('Input Form'!K23=\"\",\"\",'Input Form'!K23)","v":""},{"$f":"IF('Input Form'!L23=\"\",\"\",'Input Form'!L23)","v":""},{"$f":"IF('Input Form'!M23=\"\",\"\",'Input Form'!M23)","v":""},{"$f":"IF('Input Form'!N23=\"\",\"\",'Input Form'!N23)","v":""},{"$f":"IF('Input Form'!O23=\"\",\"\",'Input Form'!O23)","v":""}]
[8,{"$f":"IF('Input Form'!B24=\"\",\"\",'Input Form'!B24)","v":""},{"$f":"IF('Input Form'!C24=\"\",\"\",'Input Form'!C24)","v":""},{"$f":"IF('Input Form'!D24=\"\",\"\",'Input Form'!D24)","v":""},{"$f":"IF('Input Form'!E24=\"\",\"\",'Input Form'!E24)","v":""},{"$f":"IF('Input Form'!F24=\"\",\"\",'Input Form'!F24)","v":""},{"$f":"IF('Input Form'!G24=\"\",\"\",'Input Form'!G24)","v":""},{"$f":"IF('Input Form'!H24=\"\",\"\",'Input Form'!H24)","v":""},{"$f":"IF('Input Form'!I24=\"\",\"\",'Input Form'!I24)","v":""},{"$f":"IF('Input Form'!J24=\"\",\"\",'Input Form'!J24)","v":""},{"$f":"IF('Input Form'!K24=\"\",\"\",'Input Form'!K24)","v":""},{"$f":"IF('Input Form'!L24=\"\",\"\",'Input Form'!L24)","v":""},{"$f":"IF('Input Form'!M24=\"\",\"\",'Input Form'!M24)","v":""},{"$f":"IF('Input Form'!N24=\"\",\"\",'Input Form'!N24)","v":""},{"$f":"IF('Input Form'!O24=\"\",\"\",'Input Form'!O24)","v":""}]
[9,{"$f":"IF('Input Form'!B25=\"\",\"\",'Input Form'!B25)","v":""},{"$f":"IF('Input Form'!C25=\"\",\"\",'Input Form'!C25)","v":""},{"$f":"IF('Input Form'!D25=\"\",\"\",'Input Form'!D25)","v":""},{"$f":"IF('Input Form'!E25=\"\",\"\",'Input Form'!E25)","v":""},{"$f":"IF('Input Form'!F25=\"\",\"\",'Input Form'!F25)","v":""},{"$f":"IF('Input Form'!G25=\"\",\"\",'Input Form'!G25)","v":""},{"$f":"IF('Input Form'!H25=\"\",\"\",'Input Form'!H25)","v":""},{"$f":"IF('Input Form'!I25=\"\",\"\",'Input Form'!I25)","v":""},{"$f":"IF('Input Form'!J25=\"\",\"\",'Input Form'!J25)","v":""},{"$f":"IF('Input Form'!K25=\"\",\"\",'Input Form'!K25)","v":""},{"$f":"IF('Input Form'!L25=\"\",\"\",'Input Form'!L25)","v":""},{"$f":"IF('Input Form'!M25=\"\",\"\",'Input Form'!M25)","v":""},{"$f":"IF('Input Form'!N25=\"\",\"\",'Input Form'!N25)","v":""},{"$f":"IF('Input Form'!O25=\"\",\"\",'Input Form'!O25)","v":""}]
[10,{"$f":"IF('Input Form'!B26=\"\",\"\",'Input Form'!B26)","v":""},{"$f":"IF('Input Form'!C26=\"\",\"\",'Input Form'!C26)","v":""},{"$f":"IF('Input Form'!D26=\"\",\"\",'Input Form'!D26)","v":""},{"$f":"IF('Input Form'!E26=\"\",\"\",'Input Form'!E26)","v":""},{"$f":"IF('Input Form'!F26=\"\",\"\",'Input Form'!F26)","v":""},{"$f":"IF('Input Form'!G26=\"\",\"\",'Input Form'!G26)","v":""},{"$f":"IF('Input Form'!H26=\"\",\"\",'Input Form'!H26)","v":""},{"$f":"IF('Input Form'!I26=\"\",\"\",'Input Form'!I26)","v":""},{"$f":"IF('Input Form'!J26=\"\",\"\",'Input Form'!J26)","v":""},{"$f":"IF('Input Form'!K26=\"\",\"\",'Input Form'!K26)","v":""},{"$f":"IF('Input Form'!L26=\"\",\"\",'Input Form'!L26)","v":""},{"$f":"IF('Input Form'!M26=\"\",\"\",'Input Form'!M26)","v":""},{"$f":"IF('Input Form'!N26=\"\",\"\",'Input Form'!N26)","v":""},{"$f":"IF('Input Form'!O26=\"\",\"\",'Input Form'!O26)","v":""}]
[11,{"$f":"IF('Input Form'!B27=\"\",\"\",'Input Form'!B27)","v":""},{"$f":"IF('Input Form'!C27=\"\",\"\",'Input Form'!C27)","v":""},{"$f":"IF('Input Form'!D27=\"\",\"\",'Input Form'!D27)","v":""},{"$f":"IF('Input Form'!E27=\"\",\"\",'Input Form'!E27)","v":""},{"$f":"IF('Input Form'!F27=\"\",\"\",'Input Form'!F27)","v":""},{"$f":"IF('Input Form'!G27=\"\",\"\",'Input Form'!G27)","v":""},{"$f":"IF('Input Form'!H27=\"\",\"\",'Input Form'!H27)","v":""},{"$f":"IF('Input Form'!I27=\"\",\"\",'Input Form'!I27)","v":""},{"$f":"IF('Input Form'!J27=\"\",\"\",'Input Form'!J27)","v":""},{"$f":"IF('Input Form'!K27=\"\",\"\",'Input Form'!K27)","v":""},{"$f":"IF('Input Form'!L27=\"\",\"\",'Input Form'!L27)","v":""},{"$f":"IF('Input Form'!M27=\"\",\"\",'Input Form'!M27)","v":""},{"$f":"IF('Input Form'!N27=\"\",\"\",'Input Form'!N27)","v":""},{"$f":"IF('Input Form'!O27=\"\",\"\",'Input Form'!O27)","v":""}]
[12,{"$f":"IF('Input Form'!B28=\"\",\"\",'Input Form'!B28)","v":""},{"$f":"IF('Input Form'!C28=\"\",\"\",'Input Form'!C28)","v":""},{"$f":"IF('Input Form'!D28=\"\",\"\",'Input Form'!D28)","v":""},{"$f":"IF('Input Form'!E28=\"\",\"\",'Input Form'!E28)","v":""},{"$f":"IF('Input Form'!F28=\"\",\"\",'Input Form'!F28)","v":""},{"$f":"IF('Input Form'!G28=\"\",\"\",'Input Form'!G28)","v":""},{"$f":"IF('Input Form'!H28=\"\",\"\",'Input Form'!H28)","v":""},{"$f":"IF('Input Form'!I28=\"\",\"\",'Input Form'!I28)","v":""},{"$f":"IF('Input Form'!J28=\"\",\"\",'Input Form'!J28)","v":""},{"$f":"IF('Input Form'!K28=\"\",\"\",'Input Form'!K28)","v":""},{"$f":"IF('Input Form'!L28=\"\",\"\",'Input Form'!L28)","v":""},{"$f":"IF('Input Form'!M28=\"\",\"\",'Input Form'!M28)","v":""},{"$f":"IF('Input Form'!N28=\"\",\"\",'Input Form'!N28)","v":""},{"$f":"IF('Input Form'!O28=\"\",\"\",'Input Form'!O28)","v":""}]
[13,{"$f":"IF('Input Form'!B29=\"\",\"\",'Input Form'!B29)","v":""},{"$f":"IF('Input Form'!C29=\"\",\"\",'Input Form'!C29)","v":""},{"$f":"IF('Input Form'!D29=\"\",\"\",'Input Form'!D29)","v":""},{"$f":"IF('Input Form'!E29=\"\",\"\",'Input Form'!E29)","v":""},{"$f":"IF('Input Form'!F29=\"\",\"\",'Input Form'!F29)","v":""},{"$f":"IF('Input Form'!G29=\"\",\"\",'Input Form'!G29)","v":""},{"$f":"IF('Input Form'!H29=\"\",\"\",'Input Form'!H29)","v":""},{"$f":"IF('Input Form'!I29=\"\",\"\",'Input Form'!I29)","v":""},{"$f":"IF('Input Form'!J29=\"\",\"\",'Input Form'!J29)","v":""},{"$f":"IF('Input Form'!K29=\"\",\"\",'Input Form'!K29)","v":""},{"$f":"IF('Input Form'!L29=\"\",\"\",'Input Form'!L29)","v":""},{"$f":"IF('Input Form'!M29=\"\",\"\",'Input Form'!M29)","v":""},{"$f":"IF('Input Form'!N29=\"\",\"\",'Input Form'!N29)","v":""},{"$f":"IF('Input Form'!O29=\"\",\"\",'Input Form'!O29)","v":""}]
[14,{"$f":"IF('Input Form'!B30=\"\",\"\",'Input Form'!B30)","v":""},{"$f":"IF('Input Form'!C30=\"\",\"\",'Input Form'!C30)","v":""},{"$f":"IF('Input Form'!D30=\"\",\"\",'Input Form'!D30)","v":""},{"$f":"IF('Input Form'!E30=\"\",\"\",'Input Form'!E30)","v":""},{"$f":"IF('Input Form'!F30=\"\",\"\",'Input Form'!F30)","v":""},{"$f":"IF('Input Form'!G30=\"\",\"\",'Input Form'!G30)","v":""},{"$f":"IF('Input Form'!H30=\"\",\"\",'Input Form'!H30)","v":""},{"$f":"IF('Input Form'!I30=\"\",\"\",'Input Form'!I30)","v":""},{"$f":"IF('Input Form'!J30=\"\",\"\",'Input Form'!J30)","v":""},{"$f":"IF('Input Form'!K30=\"\",\"\",'Input Form'!K30)","v":""},{"$f":"IF('Input Form'!L30=\"\",\"\",'Input Form'!L30)","v":""},{"$f":"IF('Input Form'!M30=\"\",\"\",'Input Form'!M30)","v":""},{"$f":"IF('Input Form'!N30=\"\",\"\",'Input Form'!N30)","v":""},{"$f":"IF('Input Form'!O30=\"\",\"\",'Input Form'!O30)","v":""}]
[15,{"$f":"IF('Input Form'!B31=\"\",\"\",'Input Form'!B31)","v":""},{"$f":"IF('Input Form'!C31=\"\",\"\",'Input Form'!C31)","v":""},{"$f":"IF('Input Form'!D31=\"\",\"\",'Input Form'!D31)","v":""},{"$f":"IF('Input Form'!E31=\"\",\"\",'Input Form'!E31)","v":""},{"$f":"IF('Input Form'!F31=\"\",\"\",'Input Form'!F31)","v":""},{"$f":"IF('Input Form'!G31=\"\",\"\",'Input Form'!G31)","v":""},{"$f":"IF('Input Form'!H31=\"\",\"\",'Input Form'!H31)","v":""},{"$f":"IF('Input Form'!I31=\"\",\"\",'Input Form'!I31)","v":""},{"$f":"IF('Input Form'!J31=\"\",\"\",'Input Form'!J31)","v":""},{"$f":"IF('Input Form'!K31=\"\",\"\",'Input Form'!K31)","v":""},{"$f":"IF('Input Form'!L31=\"\",\"\",'Input Form'!L31)","v":""},{"$f":"IF('Input Form'!M31=\"\",\"\",'Input Form'!M31)","v":""},{"$f":"IF('Input Form'!N31=\"\",\"\",'Input Form'!N31)","v":""},{"$f":"IF('Input Form'!O31=\"\",\"\",'Input Form'!O31)","v":""}]
[16,{"$f":"IF('Input Form'!B32=\"\",\"\",'Input Form'!B32)","v":""},{"$f":"IF('Input Form'!C32=\"\",\"\",'Input Form'!C32)","v":""},{"$f":"IF('Input Form'!D32=\"\",\"\",'Input Form'!D32)","v":""},{"$f":"IF('Input Form'!E32=\"\",\"\",'Input Form'!E32)","v":""},{"$f":"IF('Input Form'!F32=\"\",\"\",'Input Form'!F32)","v":""},{"$f":"IF('Input Form'!G32=\"\",\"\",'Input Form'!G32)","v":""},{"$f":"IF('Input Form'!H32=\"\",\"\",'Input Form'!H32)","v":""},{"$f":"IF('Input Form'!I32=\"\",\"\",'Input Form'!I32)","v":""},{"$f":"IF('Input Form'!J32=\"\",\"\",'Input Form'!J32)","v":""},{"$f":"IF('Input Form'!K32=\"\",\"\",'Input Form'!K32)","v":""},{"$f":"IF('Input Form'!L32=\"\",\"\",'Input Form'!L32)","v":""},{"$f":"IF('Input Form'!M32=\"\",\"\",'Input Form'!M32)","v":""},{"$f":"IF('Input Form'!N32=\"\",\"\",'Input Form'!N32)","v":""},{"$f":"IF('Input Form'!O32=\"\",\"\",'Input Form'!O32)","v":""}]
[17,{"$f":"IF('Input Form'!B33=\"\",\"\",'Input Form'!B33)","v":""},{"$f":"IF('Input Form'!C33=\"\",\"\",'Input Form'!C33)","v":""},{"$f":"IF('Input Form'!D33=\"\",\"\",'Input Form'!D33)","v":""},{"$f":"IF('Input Form'!E33=\"\",\"\",'Input Form'!E33)","v":""},{"$f":"IF('Input Form'!F33=\"\",\"\",'Input Form'!F33)","v":""},{"$f":"IF('Input Form'!G33=\"\",\"\",'Input Form'!G33)","v":""},{"$f":"IF('Input Form'!H33=\"\",\"\",'Input Form'!H33)","v":""},{"$f":"IF('Input Form'!I33=\"\",\"\",'Input Form'!I33)","v":""},{"$f":"IF('Input Form'!J33=\"\",\"\",'Input Form'!J33)","v":""},{"$f":"IF('Input Form'!K33=\"\",\"\",'Input Form'!K33)","v":""},{"$f":"IF('Input Form'!L33=\"\",\"\",'Input Form'!L33)","v":""},{"$f":"IF('Input Form'!M33=\"\",\"\",'Input Form'!M33)","v":""},{"$f":"IF('Input Form'!N33=\"\",\"\",'Input Form'!N33)","v":""},{"$f":"IF('Input Form'!O33=\"\",\"\",'Input Form'!O33)","v":""}]
[18,{"$f":"IF('Input Form'!B34=\"\",\"\",'Input Form'!B34)","v":""},{"$f":"IF('Input Form'!C34=\"\",\"\",'Input Form'!C34)","v":""},{"$f":"IF('Input Form'!D34=\"\",\"\",'Input Form'!D34)","v":""},{"$f":"IF('Input Form'!E34=\"\",\"\",'Input Form'!E34)","v":""},{"$f":"IF('Input Form'!F34=\"\",\"\",'Input Form'!F34)","v":""},{"$f":"IF('Input Form'!G34=\"\",\"\",'Input Form'!G34)","v":""},{"$f":"IF('Input Form'!H34=\"\",\"\",'Input Form'!H34)","v":""},{"$f":"IF('Input Form'!I34=\"\",\"\",'Input Form'!I34)","v":""},{"$f":"IF('Input Form'!J34=\"\",\"\",'Input Form'!J34)","v":""},{"$f":"IF('Input Form'!K34=\"\",\"\",'Input Form'!K34)","v":""},{"$f":"IF('Input Form'!L34=\"\",\"\",'Input Form'!L34)","v":""},{"$f":"IF('Input Form'!M34=\"\",\"\",'Input Form'!M34)","v":""},{"$f":"IF('Input Form'!N34=\"\",\"\",'Input Form'!N34)","v":""},{"$f":"IF('Input Form'!O34=\"\",\"\",'Input Form'!O34)","v":""}]
[19,{"$f":"IF('Input Form'!B35=\"\",\"\",'Input Form'!B35)","v":""},{"$f":"IF('Input Form'!C35=\"\",\"\",'Input Form'!C35)","v":""},{"$f":"IF('Input Form'!D35=\"\",\"\",'Input Form'!D35)","v":""},{"$f":"IF('Input Form'!E35=\"\",\"\",'Input Form'!E35)","v":""},{"$f":"IF('Input Form'!F35=\"\",\"\",'Input Form'!F35)","v":""},{"$f":"IF('Input Form'!G35=\"\",\"\",'Input Form'!G35)","v":""},{"$f":"IF('Input Form'!H35=\"\",\"\",'Input Form'!H35)","v":""},{"$f":"IF('Input Form'!I35=\"\",\"\",'Input Form'!I35)","v":""},{"$f":"IF('Input Form'!J35=\"\",\"\",'Input Form'!J35)","v":""},{"$f":"IF('Input Form'!K35=\"\",\"\",'Input Form'!K35)","v":""},{"$f":"IF('Input Form'!L35=\"\",\"\",'Input Form'!L35)","v":""},{"$f":"IF('Input Form'!M35=\"\",\"\",'Input Form'!M35)","v":""},{"$f":"IF('Input Form'!N35=\"\",\"\",'Input Form'!N35)","v":""},{"$f":"IF('Input Form'!O35=\"\",\"\",'Input Form'!O35)","v":""}]
[20,{"$f":"IF('Input Form'!B36=\"\",\"\",'Input Form'!B36)","v":""},{"$f":"IF('Input Form'!C36=\"\",\"\",'Input Form'!C36)","v":""},{"$f":"IF('Input Form'!D36=\"\",\"\",'Input Form'!D36)","v":""},{"$f":"IF('Input Form'!E36=\"\",\"\",'Input Form'!E36)","v":""},{"$f":"IF('Input Form'!F36=\"\",\"\",'Input Form'!F36)","v":""},{"$f":"IF('Input Form'!G36=\"\",\"\",'Input Form'!G36)","v":""},{"$f":"IF('Input Form'!H36=\"\",\"\",'Input Form'!H36)","v":""},{"$f":"IF('Input Form'!I36=\"\",\"\",'Input Form'!I36)","v":""},{"$f":"IF('Input Form'!J36=\"\",\"\",'Input Form'!J36)","v":""},{"$f":"IF('Input Form'!K36=\"\",\"\",'Input Form'!K36)","v":""},{"$f":"IF('Input Form'!L36=\"\",\"\",'Input Form'!L36)","v":""},{"$f":"IF('Input Form'!M36=\"\",\"\",'Input Form'!M36)","v":""},{"$f":"IF('Input Form'!N36=\"\",\"\",'Input Form'!N36)","v":""},{"$f":"IF('Input Form'!O36=\"\",\"\",'Input Form'!O36)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(O17:O36)","v":0}]
[null,null,{"$f":"IF(A8=\"incomplete\",\"Please complete highlighted fields on the Input form Tab.\",\"\")","v":"Please complete highlighted fields on the Input form Tab."},null,null,null,null,{"$f":"IF('Input Form'!H38:K40=\"\",\"\",'Input Form'!H38:K40)","v":""},null,null,null,null,"Notes:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Input Form'!L39:O44=\"\",\"\",'Input Form'!L39:O44)","v":""}]
[]
[null,null,"Superintendent's Signature",null,null,null,null,"Date"]
[]
[null,null,{"$f":"'Input Form'!C43:D43","v":0},null,{"$f":"'Input Form'!E43","v":0},{"$f":"'Input Form'!F43:G43","v":0}]
[null,null,"Preparer's Name",null,"Preparer's E-mail","Phone #"]

{"sheet":"Data","index":2,"n_rows":58,"n_cols":27,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["Fiscal Year:","School Year:","Thetford Academy","Semester:","Vehicle/Run #","Driver's Name:","Technical Center:",null,null,null,null,null,"Estimated number of days this vehicle will Travel to the Tech Ctr this year?","Estimated number of days this \nvehicle will travel in this semester:","If transportation is contracted what \nis the per mile amount that you pay:",0,"Preparer's Name","Preparer's contact: E-mail                           Phone #",null,null,"Lea-FY-Sem-SemFY-Bus#","Phone Number"]
["txtFiscalYear","txtSemFiscalYear","txtSchoolDistirct","txtSemester","txtBusNumber","txtDriver","txtTechnicalCenter","dblOneWayMileage","intNumOneWayTrips","intTotalStudents","intTotalNonTechStudents","intDaysInSession","intDaysBusTraveled","dblContractRate","dblReimbursementRate","txtPreparersName","txtPeparersEmail","strSourceFile","txtLEA","txtTransid","strPhoneNumber","dblPrelimAmount","intYearlyContractAmount","intBusCapacity","intPYCosts"]
[{"$f":"'Input Form'!E10","v":"2013"},{"$f":"RIGHT('Input Form'!E12,4)","v":""},{"$f":"'Input Form'!E8","v":0},{"$f":"'Input Form'!E11","v":0},null,null,null,null,null,null,null,{"$f":"'Input Form'!N7","v":0},null,{"$f":"IF('Input Form'!N9=\"Reimbursement\",0,'Input Form'!N10)","v":0},{"$f":"IF('Input Form'!N9=\"Reimbursement\",'Input Form'!N10,0)","v":0},{"$f":"+'Input Form'!C43","v":0},{"$f":"'Input Form'!E43","v":0},{"$f":"\"J:\\FY\"&A3&\"\\Sean\"&RIGHT(A3,2)&\"\\Tech Ed\\Transportation\\Transportation Reimbursement Form\\To Be Loaded\\Loaded\\\"&\"\"&MID(CELL(\"filename\",P3),FIND(\"[\",CELL(\"filename\",P3))+1,(LEN(\"\"&MID(CELL(\"filename\",P3),FIND(\"[\",CELL(\"filename\",P3))+1,256))-LEN(\"\"&MID(CELL(\"filename\",P3),FIND(\"]\",CELL(\"filename\",P3))+1,256)))-1)&\"#\"&\"J:\\FY\"&A3&\"\\Sean\"&RIGHT(A3,2)&\"\\Tech Ed\\Transportation\\Transportation Reimbursement Form\\To Be Loaded\\Loaded\\\"&\"\"&MID(CELL(\"filename\",P3),FIND(\"[\",CELL(\"filename\",P3))+1,(LEN(\"\"&MID(CELL(\"filename\",P3),FIND(\"[\",CELL(\"filename\",P3))+1,256))-LEN(\"\"&MID(CELL(\"filename\",P3),FIND(\"]\",CELL(\"filename\",P3))+1,256)))-1)&\"#\"","v":"J:\\FY2013\\Sean13\\Tech Ed\\Transportation\\Transportation Reimbursement Form\\To Be Loaded\\Loaded\\FY2013 Tech Ed Transportation Form v5.1.xlsm#J:\\FY2013\\Sean13\\Tech Ed\\Transportation\\Transportation Reimbursement Form\\To Be Loaded\\Loaded\\FY2013 Tech Ed Transportation Form v5.1.xlsm#"},{"$f":"'Input Form'!E9","v":""},{"$f":"S3&D3&B3&E3","v":"0"},{"$f":"'Input Form'!F43","v":0},{"$f":"R32","v":0},{"$f":"'Input Form'!N12","v":0},null,{"$f":"'Input Form'!N8","v":0}]
[]
[]
[null,null,"State Rate",{"$f":"VLOOKUP('Input Form'!E12,Lists!$K$6:$L$7,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"Factor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J:\\FY2009\\Sean09\\Tech Ed\\Transportation\\Transportation Reimbursement Form\\To Be Loaded"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"old"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Days",null,{"$f":"Q3","v":0},null,"Total"]
["txtTripType","txtTechCenterM","txtBusNumber","txtDriver","intCapacity","intDaysTrav","intPaidRate","intTripType","intOneWayTrips","dblMilesPerTrip","intTechStudents","intNRStudents","intOtherStudents","txtTransid","txtTransidCT","Total Trips",{"$f":"SUM(I12:I17)","v":0},null,null,"Miles"]
[{"$f":"'Input Form'!E17","v":0},{"$f":"'Input Form'!F17","v":0},{"$f":"'Input Form'!B17","v":0},{"$f":"'Input Form'!C17","v":0},{"$f":"'Input Form'!D17","v":0},{"$f":"'Input Form'!L17","v":0},{"$f":"'Input Form'!N17","v":0},{"$f":"LEFT(A12,1)","v":"0"},{"$f":"'Input Form'!G17","v":0},{"$f":"'Input Form'!H17","v":0},{"$f":"'Input Form'!I17","v":0},{"$f":"'Input Form'!J17","v":0},{"$f":"'Input Form'!K17","v":0},{"$f":"IF(I12=0,\"-\",$T$3)","v":"-"},{"$f":"IF(N12=\"-\",\"-\",N12&G39)","v":"-"},"One-Way Mileage",{"$f":"IF(SUM(J12:J17)=0,0,SUM(J12:J17)/COUNTIF(J12:J17,\">0\"))","v":0},{"$f":"IF(I12>0,IF(K12+L12+M12=0,1,IF(ROUND((K12+L12)/(K12+L12+M12),4)>=0.5,1,ROUND((K12+L12)/(K12+L12+M12),4))),0)","v":0},{"$f":"IF(R12=0,0,ROUND(I12*J12*F12*G12*R12,2))","v":0},{"$f":"I12*J12*$L$3","v":0}]
[{"$f":"'Input Form'!E18","v":0},{"$f":"'Input Form'!F18","v":0},{"$f":"'Input Form'!B18","v":0},{"$f":"'Input Form'!C18","v":0},{"$f":"'Input Form'!D18","v":0},{"$f":"'Input Form'!L18","v":0},{"$f":"'Input Form'!N18","v":""},"0",{"$f":"'Input Form'!G18","v":0},{"$f":"'Input Form'!H18","v":0},{"$f":"'Input Form'!I18","v":0},{"$f":"'Input Form'!J18","v":0},{"$f":"'Input Form'!K18","v":0},"-","-","Total Tech Students",{"$f":"SUM(K12:K17)","v":0},{"$f":"IF(I13>0,IF(K13+L13+M13=0,1,IF(ROUND((K13+L13)/(K13+L13+M13),4)>=0.5,1,ROUND((K13+L13)/(K13+L13+M13),4))),0)","v":0},0,0]
[{"$f":"'Input Form'!E19","v":0},{"$f":"'Input Form'!F19","v":0},{"$f":"'Input Form'!B19","v":0},{"$f":"'Input Form'!C19","v":0},{"$f":"'Input Form'!D19","v":0},{"$f":"'Input Form'!L19","v":0},{"$f":"'Input Form'!N19","v":""},"0",{"$f":"'Input Form'!G19","v":0},{"$f":"'Input Form'!H19","v":0},{"$f":"'Input Form'!I19","v":0},{"$f":"'Input Form'!J19","v":0},{"$f":"'Input Form'!K19","v":0},"-","-","Total Non-Tech Students",{"$f":"SUM(M12:M17)","v":0},0,0,0]
[{"$f":"'Input Form'!E20","v":0},{"$f":"'Input Form'!F20","v":0},{"$f":"'Input Form'!B20","v":0},{"$f":"'Input Form'!C20","v":0},{"$f":"'Input Form'!D20","v":0},{"$f":"'Input Form'!L20","v":0},{"$f":"'Input Form'!N20","v":""},"0",{"$f":"'Input Form'!G20","v":0},{"$f":"'Input Form'!H20","v":0},{"$f":"'Input Form'!I20","v":0},{"$f":"'Input Form'!J20","v":0},{"$f":"'Input Form'!K20","v":0},"-","-","Rate",null,0,0,0]
[{"$f":"'Input Form'!E21","v":0},{"$f":"'Input Form'!F21","v":0},{"$f":"'Input Form'!B21","v":0},{"$f":"'Input Form'!C21","v":0},{"$f":"'Input Form'!D21","v":0},{"$f":"'Input Form'!L21","v":0},{"$f":"'Input Form'!N21","v":""},"0",{"$f":"'Input Form'!G21","v":0},{"$f":"'Input Form'!H21","v":0},{"$f":"'Input Form'!I21","v":0},{"$f":"'Input Form'!J21","v":0},{"$f":"'Input Form'!K21","v":0},"-","-","% Tech Students",{"$f":"IF(SUM(Q13:Q14)=0,0,Q13/SUM(Q13:Q14))","v":0},0,0,0,null,null,null,null,null,null,"Full Database Path"]
[{"$f":"'Input Form'!E22","v":0},{"$f":"'Input Form'!F22","v":0},{"$f":"'Input Form'!B22","v":0},{"$f":"'Input Form'!C22","v":0},{"$f":"'Input Form'!D22","v":0},{"$f":"'Input Form'!L22","v":0},{"$f":"'Input Form'!N22","v":""},"0",{"$f":"'Input Form'!G22","v":0},{"$f":"'Input Form'!H22","v":0},{"$f":"'Input Form'!I22","v":0},{"$f":"'Input Form'!J22","v":0},{"$f":"'Input Form'!K22","v":0},"-","-","Prelim-Reimb",{"$f":"IF(Q16>=0.5,Q11*Q10*Q12*Q15,Q11*Q12*Q15*Q16*Q10)","v":0},0,0,0,null,null,null,null,null,null,"Table Name"]
[{"$f":"'Input Form'!E23","v":0},{"$f":"'Input Form'!F23","v":0},{"$f":"'Input Form'!B23","v":0},{"$f":"'Input Form'!C23","v":0},{"$f":"'Input Form'!D23","v":0},{"$f":"'Input Form'!L23","v":0},{"$f":"'Input Form'!N23","v":""},"0",{"$f":"'Input Form'!G23","v":0},{"$f":"'Input Form'!H23","v":0},{"$f":"'Input Form'!I23","v":0},{"$f":"'Input Form'!J23","v":0},{"$f":"'Input Form'!K23","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E24","v":0},{"$f":"'Input Form'!F24","v":0},{"$f":"'Input Form'!B24","v":0},{"$f":"'Input Form'!C24","v":0},{"$f":"'Input Form'!D24","v":0},{"$f":"'Input Form'!L24","v":0},{"$f":"'Input Form'!N24","v":""},"0",{"$f":"'Input Form'!G24","v":0},{"$f":"'Input Form'!H24","v":0},{"$f":"'Input Form'!I24","v":0},{"$f":"'Input Form'!J24","v":0},{"$f":"'Input Form'!K24","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E25","v":0},{"$f":"'Input Form'!F25","v":0},{"$f":"'Input Form'!B25","v":0},{"$f":"'Input Form'!C25","v":0},{"$f":"'Input Form'!D25","v":0},{"$f":"'Input Form'!L25","v":0},{"$f":"'Input Form'!N25","v":""},"0",{"$f":"'Input Form'!G25","v":0},{"$f":"'Input Form'!H25","v":0},{"$f":"'Input Form'!I25","v":0},{"$f":"'Input Form'!J25","v":0},{"$f":"'Input Form'!K25","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E26","v":0},{"$f":"'Input Form'!F26","v":0},{"$f":"'Input Form'!B26","v":0},{"$f":"'Input Form'!C26","v":0},{"$f":"'Input Form'!D26","v":0},{"$f":"'Input Form'!L26","v":0},{"$f":"'Input Form'!N26","v":""},"0",{"$f":"'Input Form'!G26","v":0},{"$f":"'Input Form'!H26","v":0},{"$f":"'Input Form'!I26","v":0},{"$f":"'Input Form'!J26","v":0},{"$f":"'Input Form'!K26","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E27","v":0},{"$f":"'Input Form'!F27","v":0},{"$f":"'Input Form'!B27","v":0},{"$f":"'Input Form'!C27","v":0},{"$f":"'Input Form'!D27","v":0},{"$f":"'Input Form'!L27","v":0},{"$f":"'Input Form'!N27","v":""},"0",{"$f":"'Input Form'!G27","v":0},{"$f":"'Input Form'!H27","v":0},{"$f":"'Input Form'!I27","v":0},{"$f":"'Input Form'!J27","v":0},{"$f":"'Input Form'!K27","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E28","v":0},{"$f":"'Input Form'!F28","v":0},{"$f":"'Input Form'!B28","v":0},{"$f":"'Input Form'!C28","v":0},{"$f":"'Input Form'!D28","v":0},{"$f":"'Input Form'!L28","v":0},{"$f":"'Input Form'!N28","v":""},"0",{"$f":"'Input Form'!G28","v":0},{"$f":"'Input Form'!H28","v":0},{"$f":"'Input Form'!I28","v":0},{"$f":"'Input Form'!J28","v":0},{"$f":"'Input Form'!K28","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E29","v":0},{"$f":"'Input Form'!F29","v":0},{"$f":"'Input Form'!B29","v":0},{"$f":"'Input Form'!C29","v":0},{"$f":"'Input Form'!D29","v":0},{"$f":"'Input Form'!L29","v":0},{"$f":"'Input Form'!N29","v":""},"0",{"$f":"'Input Form'!G29","v":0},{"$f":"'Input Form'!H29","v":0},{"$f":"'Input Form'!I29","v":0},{"$f":"'Input Form'!J29","v":0},{"$f":"'Input Form'!K29","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E30","v":0},{"$f":"'Input Form'!F30","v":0},{"$f":"'Input Form'!B30","v":0},{"$f":"'Input Form'!C30","v":0},{"$f":"'Input Form'!D30","v":0},{"$f":"'Input Form'!L30","v":0},{"$f":"'Input Form'!N30","v":""},"0",{"$f":"'Input Form'!G30","v":0},{"$f":"'Input Form'!H30","v":0},{"$f":"'Input Form'!I30","v":0},{"$f":"'Input Form'!J30","v":0},{"$f":"'Input Form'!K30","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E31","v":0},{"$f":"'Input Form'!F31","v":0},{"$f":"'Input Form'!B31","v":0},{"$f":"'Input Form'!C31","v":0},{"$f":"'Input Form'!D31","v":0},{"$f":"'Input Form'!L31","v":0},{"$f":"'Input Form'!N31","v":""},"0",{"$f":"'Input Form'!G31","v":0},{"$f":"'Input Form'!H31","v":0},{"$f":"'Input Form'!I31","v":0},{"$f":"'Input Form'!J31","v":0},{"$f":"'Input Form'!K31","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E32","v":0},{"$f":"'Input Form'!F32","v":0},{"$f":"'Input Form'!B32","v":0},{"$f":"'Input Form'!C32","v":0},{"$f":"'Input Form'!D32","v":0},{"$f":"'Input Form'!L32","v":0},{"$f":"'Input Form'!N32","v":""},"0",{"$f":"'Input Form'!G32","v":0},{"$f":"'Input Form'!H32","v":0},{"$f":"'Input Form'!I32","v":0},{"$f":"'Input Form'!J32","v":0},{"$f":"'Input Form'!K32","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E33","v":0},{"$f":"'Input Form'!F33","v":0},{"$f":"'Input Form'!B33","v":0},{"$f":"'Input Form'!C33","v":0},{"$f":"'Input Form'!D33","v":0},{"$f":"'Input Form'!L33","v":0},{"$f":"'Input Form'!N33","v":""},"0",{"$f":"'Input Form'!G33","v":0},{"$f":"'Input Form'!H33","v":0},{"$f":"'Input Form'!I33","v":0},{"$f":"'Input Form'!J33","v":0},{"$f":"'Input Form'!K33","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E34","v":0},{"$f":"'Input Form'!F34","v":0},{"$f":"'Input Form'!B34","v":0},{"$f":"'Input Form'!C34","v":0},{"$f":"'Input Form'!D34","v":0},{"$f":"'Input Form'!L34","v":0},{"$f":"'Input Form'!N34","v":""},"0",{"$f":"'Input Form'!G34","v":0},{"$f":"'Input Form'!H34","v":0},{"$f":"'Input Form'!I34","v":0},{"$f":"'Input Form'!J34","v":0},{"$f":"'Input Form'!K34","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E35","v":0},{"$f":"'Input Form'!F35","v":0},{"$f":"'Input Form'!B35","v":0},{"$f":"'Input Form'!C35","v":0},{"$f":"'Input Form'!D35","v":0},{"$f":"'Input Form'!L35","v":0},{"$f":"'Input Form'!N35","v":""},"0",{"$f":"'Input Form'!G35","v":0},{"$f":"'Input Form'!H35","v":0},{"$f":"'Input Form'!I35","v":0},{"$f":"'Input Form'!J35","v":0},{"$f":"'Input Form'!K35","v":0},"-","-",null,null,0,0,0]
[{"$f":"'Input Form'!E36","v":0},{"$f":"'Input Form'!F36","v":0},{"$f":"'Input Form'!B36","v":0},{"$f":"'Input Form'!C36","v":0},{"$f":"'Input Form'!D36","v":0},{"$f":"'Input Form'!L36","v":0},{"$f":"'Input Form'!N36","v":""},"0",{"$f":"'Input Form'!G36","v":0},{"$f":"'Input Form'!H36","v":0},{"$f":"'Input Form'!I36","v":0},{"$f":"'Input Form'!J36","v":0},{"$f":"'Input Form'!K36","v":0},"-","-",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S12:S31)","v":0},{"$f":"SUM(T12:T31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W3","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S33/S32","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["txtSchoolDistrict","txtLEAID","intNumofStudents","dblPercOfStudents","txtTransid","txtTransIDCT"]
[{"$f":"+'Input Form'!F56","v":0},{"$f":"+'Input Form'!G56","v":""},{"$f":"+'Input Form'!H56","v":0},{"$f":"+'Input Form'!I56","v":""},{"$f":"IF(A39=0,\"-\",$T$3)","v":"-"},{"$f":"IF(E39=\"-\",\"-\",E39&G39)","v":"-"},1]
[{"$f":"+'Input Form'!F57","v":0},{"$f":"+'Input Form'!G57","v":""},{"$f":"+'Input Form'!H57","v":0},{"$f":"+'Input Form'!I57","v":""},"-","-",{"$f":"+G39+1","v":2}]
[{"$f":"+'Input Form'!F58","v":0},{"$f":"+'Input Form'!G58","v":""},{"$f":"+'Input Form'!H58","v":0},{"$f":"+'Input Form'!I58","v":""},"-","-",{"$f":"+G40+1","v":3}]
[{"$f":"+'Input Form'!F59","v":0},{"$f":"+'Input Form'!G59","v":""},{"$f":"+'Input Form'!H59","v":0},{"$f":"+'Input Form'!I59","v":""},"-","-",4]
[{"$f":"+'Input Form'!F60","v":0},{"$f":"+'Input Form'!G60","v":""},{"$f":"+'Input Form'!H60","v":0},{"$f":"+'Input Form'!I60","v":""},"-","-",5]
[{"$f":"+'Input Form'!F61","v":0},{"$f":"+'Input Form'!G61","v":""},{"$f":"+'Input Form'!H61","v":0},{"$f":"+'Input Form'!I61","v":""},"-","-",6]
[{"$f":"+'Input Form'!F62","v":0},{"$f":"+'Input Form'!G62","v":""},{"$f":"+'Input Form'!H62","v":0},{"$f":"+'Input Form'!I62","v":""},"-","-",7,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"&MID(CELL(\"filename\",Q45),FIND(\"[\",CELL(\"filename\",Q45))+1,(LEN(\"\"&MID(CELL(\"filename\",Q45),FIND(\"[\",CELL(\"filename\",Q45))+1,256))-LEN(\"\"&MID(CELL(\"filename\",Q45),FIND(\"]\",CELL(\"filename\",Q45))+1,256)))-1)","v":"FY2013 Tech Ed Transportation Form v5.1.xlsm"}]
[{"$f":"+'Input Form'!F63","v":0},{"$f":"+'Input Form'!G63","v":""},{"$f":"+'Input Form'!H63","v":0},{"$f":"+'Input Form'!I63","v":""},"-","-",8]
[{"$f":"+'Input Form'!F64","v":0},{"$f":"+'Input Form'!G64","v":""},{"$f":"+'Input Form'!H64","v":0},{"$f":"+'Input Form'!I64","v":""},"-","-",9]
[{"$f":"+'Input Form'!F65","v":0},{"$f":"+'Input Form'!G65","v":""},{"$f":"+'Input Form'!H65","v":0},{"$f":"+'Input Form'!I65","v":""},"-","-",10]
[{"$f":"+'Input Form'!F66","v":0},{"$f":"+'Input Form'!G66","v":""},{"$f":"+'Input Form'!H66","v":0},{"$f":"+'Input Form'!I66","v":""},"-","-",11]
[{"$f":"+'Input Form'!F67","v":0},{"$f":"+'Input Form'!G67","v":""},{"$f":"+'Input Form'!H67","v":0},{"$f":"+'Input Form'!I67","v":""},"-","-",12]
[{"$f":"+'Input Form'!F68","v":0},{"$f":"+'Input Form'!G68","v":""},{"$f":"+'Input Form'!H68","v":0},{"$f":"+'Input Form'!I68","v":""},"-","-",13]
[{"$f":"+'Input Form'!F69","v":0},{"$f":"+'Input Form'!G69","v":""},{"$f":"+'Input Form'!H69","v":0},{"$f":"+'Input Form'!I69","v":""},"-","-",14]
[{"$f":"+'Input Form'!F70","v":0},{"$f":"+'Input Form'!G70","v":""},{"$f":"+'Input Form'!H70","v":0},{"$f":"+'Input Form'!I70","v":""},"-","-",15]
[null,null,null,null,null,null,16]
[null,null,null,null,null,null,17]
[null,null,null,null,null,null,18]
[null,null,null,null,null,null,19]
[null,null,null,null,null,null,20]

{"sheet":"Lists","index":3,"n_rows":179,"n_cols":14,"rows_kept":179,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["Entity",null,"District/Academy","LEA","SU","Technical Center","Fiscal Year","Sem","District","LEA","School Year","State Rate","Pay Type","Trip Type"]
["Sending School District",null,"Alburgh","T003","ADDISON CENTRAL SU","BARRE TECH CTR/SHS CAMPUS",null,"1","Alburgh","T003","2012-2013",2.38,"District Operated","1 Sending School to Tech Center"]
["Technical Center",null,"Arlington","T005","ADDISON NORTHEAST SU","BURLINGTON TECHNICAL CENTER",null,"2","Arlington","T005","2011-2012",2.33,"Reimbursement","2 Tech Center to Sending School"]
["Independent School",null,"Averill","T256","ADDISON NORTHWEST SU","CENTER FOR TECHNOLOGY ESSEX",null,null,"Bakersfield","T007",null,null,"Contract by Mile","3 Sending School to Satellite Program"]
[null,null,"Avery's Gore","T257","ADDISON RUTLAND SU","COLD HOLLOW CAREER CENTER",null,null,"Baltimore","T008",null,null,"Contract by trip","4 Satellite Program to Sending School"]
[null,null,"Bakersfield","T007","BARRE SU","GREEN MTN TECHNOLOGY/CAREER CTR",null,null,"Barnet","T010",null,null,null,"5 Tech Center to Satellite Program"]
[null,null,"Baltimore","T008","BATTENKILL VALLEY SU","HARTFORD AREA CAREER/TECH CTR",null,null,"Berkshire","T018",null,null,null,"6 Satellite Program to Tech Center"]
[null,null,"Barnet","T010","BENNINGTON RUTLAND SU","LYNDON INSTITUTE",null,null,"Bethel","T020"]
[null,null,"Bellows Falls UHSD","U027","BLUE MOUNTAIN SD","NORTH COUNTRY CAREER CTR",null,null,"Bloomfield","T021"]
[null,null,"Bellows Free Academy UHSD","U048","BURLINGTON SD","NORTHWEST TECHNICAL CENTER",null,null,"Brunswick","T035"]
[null,null,"Berkshire","T018","CALEDONIA CENTRAL SU","PATRICIA HANNAFORD CAREER CTR",null,null,"Burke","T036"]
[null,null,"Bethel","T020","CALEDONIA NORTH SU","RANDOLPH TECHNICAL CAREER CTR",null,null,"Burlington","T037"]
[null,null,"Black River UHSD","U039","CHITTENDEN CENTRAL SU","RIVER BEND CAREER AND TECH CTR",null,null,"Cabot","T038"]
[null,null,"Bloomfield","T021","CHITTENDEN EAST SU","RIVER VALLEY TECHNICAL CENTER",null,null,"Canaan","T041"]
[null,null,"Blue Mountain USD","U021","CHITTENDEN SOUTH SU","ST. JOHNSBURY ACADEMY",null,null,"Chelsea","T046"]
[null,null,"Brattleboro UHSD","U006","COLCHESTER SD","STAFFORD TECHNICAL CENTER",null,null,"Chittenden","T048"]
[null,null,"Brunswick","T035","ESSEX CALEDONIA SU","SW VT CAREER DEVELOPMENT CTR",null,null,"Colchester","T050"]
[null,null,"Buel's Gore","T255","ESSEX NORTH SU","WINDHAM REGIONAL CAREER CTR",null,null,"Concord","T051"]
[null,null,"Burke","T036","ESSEX TOWN SD",null,null,null,"Coventry","T054"]
[null,null,"Burlington","T037","FRANKLIN CENTRAL SU",null,null,null,"Craftsbury","T055"]
[null,null,"Burr & Burton Academy","P002","FRANKLIN NORTHEAST SU",null,null,null,"Danby","T056"]
[null,null,"Cabot","T038","FRANKLIN NORTHWEST SU",null,null,null,"Danville","T057"]
[null,null,"Canaan","T041","FRANKLIN WEST SU",null,null,null,"Dorset","T059"]
[null,null,"Castleton-Hubbardton UESD","U042","GRAND ISLE SU",null,null,null,"Dover","T060"]
[null,null,"Champlain Valley UHSD","U015","HARTFORD SD",null,null,null,"East Haven","T064"]
[null,null,"Chelsea","T046","LAMOILLE NORTH SU",null,null,null,"Elmore","T067"]
[null,null,"Chester-Andover UESD","U029","LAMOILLE SOUTH SU",null,null,null,"Enosburg Falls ID","T068"]
[null,null,"Chittenden","T048","MILTON SD",null,null,null,"Fairfax","T071"]
[null,null,"Colchester","T050","MONTPELIER SD",null,null,null,"Fairfield","T072"]
[null,null,"Concord","T051","ORANGE EAST SU",null,null,null,"Fletcher","T077"]
[null,null,"Coventry","T054","ORANGE NORTH SU",null,null,null,"Georgia","T079"]
[null,null,"Craftsbury","T055","ORANGE SOUTHWEST SU",null,null,null,"Granby","T083"]
[null,null,"Currier Memorial UESD","U023","ORANGE WINDSOR SU",null,null,null,"Grand Isle","T084"]
[null,null,"Danby","T056","ORLEANS CENTRAL SU",null,null,null,"Granville","T085"]
[null,null,"Danville","T057","ORLEANS ESSEX NORTH SU",null,null,null,"Guildhall","T088"]
[null,null,"Dorset","T059","ORLEANS SOUTHWEST SU",null,null,null,"Halifax","T090"]
[null,null,"Dover","T060","RIVENDELL INTERSTATE SCHOOL DISTRICT",null,null,null,"Hancock","T091"]
[null,null,"Duxbury-Waterbury UESD","U045","RUTLAND CENTRAL SU",null,null,null,"Hartford","T093"]
[null,null,"East Haven","T064","RUTLAND CITY SD",null,null,null,"Hartland","T094"]
[null,null,"Elmore","T067","RUTLAND NORTHEAST SU",null,null,null,"Hubbardton","T098"]
[null,null,"Enosburg Falls ID","T068","RUTLAND SOUTH SU",null,null,null,"Ira","T101"]
[null,null,"Essex Comm. Ed. Ctr. UHSD","U046","RUTLAND SOUTHWEST SU",null,null,null,"Isle La Motte","T103"]
[null,null,"Fair Haven UHSD","U016","RUTLAND WINDSOR SU",null,null,null,"Kirby","T108"]
[null,null,"Fairfax","T071","SAU 70 ",null,null,null,"Landgrove","T109"]
[null,null,"Fairfield","T072","SOUTH BURLINGTON SD",null,null,null,"Lemington","T111"]
[null,null,"Ferdinand","T258","SOUTHWEST VERMONT SU",null,null,null,"Londonderry","T113"]
[null,null,"Fletcher","T077","SPRINGFIELD SD",null,null,null,"Lunenburg","T116"]
[null,null,"Flood Brook UESD","U020","ST JOHNSBURY SD",null,null,null,"Lyndon","T117"]
[null,null,"Georgia","T079","VERMONT PRINCIPALS ASSOCIATION",null,null,null,"Maidstone","T118"]
[null,null,"Glastenbury","T259","WASHINGTON CENTRAL SU",null,null,null,"Manchester","T119"]
[null,null,"Granby","T083","WASHINGTON NORTHEAST SU",null,null,null,"Marlboro","T120"]
[null,null,"Grand Isle","T084","WASHINGTON SOUTH SU",null,null,null,"Mendon","T122"]
[null,null,"Granville","T085","WASHINGTON WEST SU",null,null,null,"Middletown Springs","T125"]
[null,null,"Green Mountain UHSD","U035","WINDHAM CENTRAL SU",null,null,null,"Milton ID","T126"]
[null,null,"Guildhall","T088","WINDHAM NORTHEAST SU",null,null,null,"Montgomery","T128"]
[null,null,"Halifax","T090","WINDHAM SOUTHEAST SU",null,null,null,"Montpelier","T129"]
[null,null,"Hancock","T091","WINDHAM SOUTHWEST SU",null,null,null,"Morristown","T132"]
[null,null,"Hartford","T093","WINDSOR CENTRAL SU",null,null,null,"Mt. Tabor","T134"]
[null,null,"Hartland","T094","WINDSOR NORTHWEST SU",null,null,null,"Newark","T135"]
[null,null,"Harwood UHSD","U019","WINDSOR SOUTHEAST SU",null,null,null,"Northfield","T142"]
[null,null,"Hazen UHSD","U026","WINDSOR SOUTHWEST SU",null,null,null,"North Hero","T143"]
[null,null,"Hubbardton","T098","WINOOSKI SD",null,null,null,"Norton","T144"]
[null,null,"Ira","T101","N/A",null,null,null,"Norwich","T145"]
[null,null,"Isle La Motte","T103",null,null,null,null,"Orange","T146"]
[null,null,"Kirby","T108",null,null,null,null,"Pawlet","T150"]
[null,null,"Lake Region UHSD","U024",null,null,null,null,"Peacham","T151"]
[null,null,"Lakeview UESD","U043",null,null,null,null,"Peru","T152"]
[null,null,"Lamoille UHSD","U018",null,null,null,null,"Pittsfield","T153"]
[null,null,"Landgrove","T109",null,null,null,null,"Plymouth","T156"]
[null,null,"Leland & Gray UHSD","U034",null,null,null,null,"Poultney","T158"]
[null,null,"Lemington","T111",null,null,null,null,"Proctor","T160"]
[null,null,"Lewis","T260",null,null,null,null,"Readsboro","T164"]
[null,null,"Londonderry","T113",null,null,null,null,"Richford","T165"]
[null,null,"Lunenburg","T116",null,null,null,null,"Rochester","T168"]
[null,null,"Lyndon","T117",null,null,null,null,"Roxbury","T170"]
[null,null,"Lyndon Institute","P003",null,null,null,null,"Royalton","T171"]
[null,null,"Maidstone","T118",null,null,null,null,"Rupert","T172"]
[null,null,"Manchester","T119",null,null,null,null,"Rutland City","T173"]
[null,null,"Marlboro","T120",null,null,null,null,"Rutland Town","T174"]
[null,null,"Mendon","T122",null,null,null,null,"St. George","T178"]
[null,null,"Mettawee Community Sch UESD","U047",null,null,null,null,"St. Johnsbury","T179"]
[null,null,"Middlebury UHSD","U003",null,null,null,null,"Sandgate","T181"]
[null,null,"Middletown Springs","T125",null,null,null,null,"Searsburg","T182"]
[null,null,"Mill River UHSD","U040",null,null,null,null,"Sharon","T184"]
[null,null,"Millers Run UESD","U037",null,null,null,null,"Sheldon","T187"]
[null,null,"Milton ID","T126",null,null,null,null,"South Burlington","T191"]
[null,null,"Missisquoi Valley UHSD","U007",null,null,null,null,"South Hero","T192"]
[null,null,"Montgomery","T128",null,null,null,null,"Springfield","T193"]
[null,null,"Montpelier","T129",null,null,null,null,"Stamford","T194"]
[null,null,"Morristown","T132",null,null,null,null,"Stannard","T195"]
[null,null,"Mt. Abraham UHSD","U028",null,null,null,null,"Stockbridge","T197"]
[null,null,"Mt. Anthony UHSD","U014",null,null,null,null,"Stowe","T198"]
[null,null,"Mt. Mansfield USD","U017",null,null,null,null,"Strafford","T199"]
[null,null,"Mt. Tabor","T134",null,null,null,null,"Stratton","T200"]
[null,null,"Newark","T135",null,null,null,null,"Sunderland","T202"]
[null,null,"North Country Jr UHSD","U022A",null,null,null,null,"Sutton","T203"]
[null,null,"North Country Sr UHSD","U022B",null,null,null,null,"Thetford","T205"]
[null,null,"North Hero","T143",null,null,null,null,"Tinmouth","T206"]
[null,null,"Northfield","T142",null,null,null,null,"Tunbridge","T210"]
[null,null,"Norton","T144",null,null,null,null,"Victory","T216"]
[null,null,"Norwich","T145",null,null,null,null,"Walden","T218"]
[null,null,"Orange","T146",null,null,null,null,"Wardsboro","T221"]
[null,null,"Otter Valley UHSD","U008",null,null,null,null,"Washington","T223"]
[null,null,"Oxbow UHSD","U030",null,null,null,null,"Waterford","T225"]
[null,null,"PATRICIA HANNAFORD CAREER CTR","V001",null,null,null,null,"Weathersfield","T227"]
[null,null,"Pawlet","T150",null,null,null,null,"Wells","T228"]
[null,null,"Peacham","T151",null,null,null,null,"Westford","T232"]
[null,null,"Peru","T152",null,null,null,null,"Weston","T236"]
[null,null,"Pittsfield","T153",null,null,null,null,"West Rutland","T237"]
[null,null,"Plymouth","T156",null,null,null,null,"West Windsor","T238"]
[null,null,"Poultney","T158",null,null,null,null,"Whitingham","T242"]
[null,null,"Proctor","T160",null,null,null,null,"Williamstown","T243"]
[null,null,"Randolph UHSD","U002",null,null,null,null,"Wilmington","T245"]
[null,null,"Readsboro","T164",null,null,null,null,"Windsor","T247"]
[null,null,"Richford","T165",null,null,null,null,"Winhall","T248"]
[null,null,"Rivendell Interstate USD","U146",null,null,null,null,"Winooski ID","T249"]
[null,null,"RIVER VALLEY TECHNICAL CENTER","V016",null,null,null,null,"Wolcott","T250"]
[null,null,"Rochester","T168",null,null,null,null,"Buel's Gore","T255"]
[null,null,"Roxbury","T170",null,null,null,null,"Averill","T256"]
[null,null,"Royalton","T171",null,null,null,null,"Avery's Gore","T257"]
[null,null,"Rupert","T172",null,null,null,null,"Ferdinand","T258"]
[null,null,"Rutland City","T173",null,null,null,null,"Glastenbury","T259"]
[null,null,"Rutland Town","T174",null,null,null,null,"Lewis","T260"]
[null,null,"Sandgate","T181",null,null,null,null,"Somerset","T261"]
[null,null,"Searsburg","T182",null,null,null,null,"Warner's Grant","T262"]
[null,null,"Sharon","T184",null,null,null,null,"Warren's Gore","T263"]
[null,null,"Sheldon","T187",null,null,null,null,"Randolph UHSD","U002"]
[null,null,"Somerset","T261",null,null,null,null,"Middlebury UHSD","U003"]
[null,null,"South Burlington","T191",null,null,null,null,"Woodstock UHSD","U004"]
[null,null,"South Hero","T192",null,null,null,null,"Vergennes UHSD","U005"]
[null,null,"Spaulding UHSD","U041",null,null,null,null,"Brattleboro UHSD","U006"]
[null,null,"Springfield","T193",null,null,null,null,"Missisquoi Valley UHSD","U007"]
[null,null,"St. George","T178",null,null,null,null,"Otter Valley UHSD","U008"]
[null,null,"St. Johnsbury","T179",null,null,null,null,"Mt. Anthony UHSD","U014"]
[null,null,"St. Johnsbury Academy","P004",null,null,null,null,"Champlain Valley UHSD","U015"]
[null,null,"Stamford","T194",null,null,null,null,"Fair Haven UHSD","U016"]
[null,null,"Stannard","T195",null,null,null,null,"Mt. Mansfield USD","U017"]
[null,null,"Stockbridge","T197",null,null,null,null,"Lamoille UHSD","U018"]
[null,null,"Stowe","T198",null,null,null,null,"Harwood UHSD","U019"]
[null,null,"Strafford","T199",null,null,null,null,"Flood Brook UESD","U020"]
[null,null,"Stratton","T200",null,null,null,null,"Blue Mountain USD","U021"]
[null,null,"Sunderland","T202",null,null,null,null,"North Country Jr UHSD","U022A"]
[null,null,"Sutton","T203",null,null,null,null,"North Country Sr UHSD","U022B"]
[null,null,"SW VT CAREER DEVELOPMENT CTR","V009",null,null,null,null,"Currier Memorial UESD","U023"]
[null,null,"Thetford","T205",null,null,null,null,"Lake Region UHSD","U024"]
[null,null,"Thetford Academy","P005",null,null,null,null,"Hazen UHSD","U026"]
[null,null,"Tinmouth","T206",null,null,null,null,"Bellows Falls UHSD","U027"]
[null,null,"Tunbridge","T210",null,null,null,null,"Mt. Abraham UHSD","U028"]
[null,null,"Twin Valley High School","J242",null,null,null,null,"Chester-Andover UESD","U029"]
[null,null,"Twinfield USD","U033",null,null,null,null,"Oxbow UHSD","U030"]
[null,null,"U-32 UHSD","U032",null,null,null,null,"U-32 UHSD","U032"]
[null,null,"Vergennes UESD","U044",null,null,null,null,"Twinfield USD","U033"]
[null,null,"Vergennes UHSD","U005",null,null,null,null,"Leland & Gray UHSD","U034"]
[null,null,"Victory","T216",null,null,null,null,"Green Mountain UHSD","U035"]
[null,null,"Waits River Valley UESD","U036",null,null,null,null,"Waits River Valley UESD","U036"]
[null,null,"Walden","T218",null,null,null,null,"Millers Run UESD","U037"]
[null,null,"Wardsboro","T221",null,null,null,null,"Black River UHSD","U039"]
[null,null,"Warner's Grant","T262",null,null,null,null,"Mill River UHSD","U040"]
[null,null,"Warren's Gore","T263",null,null,null,null,"Spaulding UHSD","U041"]
[null,null,"Washington","T223",null,null,null,null,"Castleton-Hubbardton UESD","U042"]
[null,null,"Waterford","T225",null,null,null,null,"Lakeview UESD","U043"]
[null,null,"Weathersfield","T227",null,null,null,null,"Vergennes UESD","U044"]
[null,null,"Wells","T228",null,null,null,null,"Duxbury-Waterbury UESD","U045"]
[null,null,"West Rutland","T237",null,null,null,null,"Essex Comm. Ed. Ctr. UHSD","U046"]
[null,null,"West Windsor","T238",null,null,null,null,"Mettawee Community Sch UESD","U047"]
[null,null,"Westford","T232",null,null,null,null,"Bellows Free Academy UHSD","U048"]
[null,null,"Weston","T236",null,null,null,null,"Rivendell Interstate USD","U146"]
[null,null,"Whitingham","T242"]
[null,null,"Williamstown","T243"]
[null,null,"Wilmington","T245"]
[null,null,"Windsor","T247"]
[null,null,"Winhall","T248"]
[null,null,"Winooski ID","T249"]
[null,null,"Wolcott","T250"]
[null,null,"Woodstock UHSD","U004"]